Walmart Sales Data Profiling Report

Dataset statistics

Number of variables	18
Number of observations	536634
Missing cells	3454897
Missing cells (%)	35.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	73.7 MiB
Average record size in memory	144.0 B

Variable types

Numeric	13
DateTime	1
Boolean	3
Categorical	1

Alerts

`IsHoliday_x` is highly overall correlated with `IsHoliday_y`	High correlation
`IsHoliday_y` is highly overall correlated with `IsHoliday_x`	High correlation
`MarkDown1` is highly overall correlated with `MarkDown4` and 1 other fields	High correlation
`MarkDown4` is highly overall correlated with `MarkDown1`	High correlation
`MarkDown5` is highly overall correlated with `MarkDown1` and 1 other fields	High correlation
`Size` is highly overall correlated with `MarkDown5` and 1 other fields	High correlation
`Store` is highly overall correlated with `Type`	High correlation
`Type` is highly overall correlated with `Size` and 1 other fields	High correlation
`IsHoliday_x` is highly imbalanced (63.3%)	Imbalance
`IsHoliday_y` is highly imbalanced (63.3%)	Imbalance
`IsHoliday` is highly imbalanced (60.6%)	Imbalance
`Weekly_Sales` has 115064 (21.4%) missing values	Missing
`IsHoliday_x` has 115064 (21.4%) missing values	Missing
`Temperature` has 115064 (21.4%) missing values	Missing
`Fuel_Price` has 115064 (21.4%) missing values	Missing
`MarkDown1` has 385953 (71.9%) missing values	Missing
`MarkDown2` has 425386 (79.3%) missing values	Missing
`MarkDown3` has 399543 (74.5%) missing values	Missing
`MarkDown4` has 401667 (74.8%) missing values	Missing
`MarkDown5` has 385202 (71.8%) missing values	Missing
`CPI` has 115064 (21.4%) missing values	Missing
`Unemployment` has 115064 (21.4%) missing values	Missing
`IsHoliday_y` has 115064 (21.4%) missing values	Missing
`Type` has 115064 (21.4%) missing values	Missing
`Size` has 115064 (21.4%) missing values	Missing
`IsHoliday` has 421570 (78.6%) missing values	Missing

Reproduction

Analysis started	2025-02-24 22:12:05.726242
Analysis finished	2025-02-24 22:13:16.957604
Duration	1 minute and 11.23 seconds
Software version	ydata-profiling vv4.12.2
Download configuration	config.json

Store
Real number (ℝ)

High correlation

Distinct	45
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.208621

Minimum	1
Maximum	45
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.1 MiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	11
median	22
Q3	33
95-th percentile	43
Maximum	45
Range	44
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	12.79058
Coefficient of variation (CV)	0.57592862
Kurtosis	-1.1472033
Mean	22.208621
Median Absolute Deviation (MAD)	11
Skewness	0.077554812
Sum	11917901
Variance	163.59895
Monotonicity	Increasing

Histogram with fixed size bins (bins=45)

Value	Count	Frequency (%)
13	13310	2.5%
10	13097	2.4%
4	13075	2.4%
2	13035	2.4%
1	13027	2.4%
24	13018	2.4%
27	13016	2.4%
6	12999	2.4%
34	12991	2.4%
20	12988	2.4%
Other values (35)	406078	75.7%

Value	Count	Frequency (%)
1	13027	2.4%
2	13035	2.4%
3	11509	2.1%
4	13075	2.4%
5	11446	2.1%
6	12999	2.4%
7	12431	2.3%
8	12594	2.3%
9	11302	2.1%
10	13097	2.4%

Value	Count	Frequency (%)
45	12263	2.3%
44	9241	1.7%
43	8614	1.6%
42	8915	1.7%
41	12842	2.4%
40	12755	2.4%
39	12582	2.3%
38	9349	1.7%
37	9219	1.7%
36	7940	1.5%

Dept
Real number (ℝ)

Distinct	81
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	44.277301

Minimum	1
Maximum	99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.1 MiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	18
median	37
Q3	74
95-th percentile	95
Maximum	99
Range	98
Interquartile range (IQR)	56

Descriptive statistics

Standard deviation	30.527358
Coefficient of variation (CV)	0.68945843
Kurtosis	-1.2174062
Mean	44.277301
Median Absolute Deviation (MAD)	23
Skewness	0.35914961
Sum	23760705
Variance	931.9196
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	8190	1.5%
16	8190	1.5%
92	8190	1.5%
38	8190	1.5%
40	8190	1.5%
2	8190	1.5%
82	8190	1.5%
46	8190	1.5%
95	8190	1.5%
81	8190	1.5%
Other values (71)	454734	84.7%

Value	Count	Frequency (%)
1	8190	1.5%
2	8190	1.5%
3	8190	1.5%
4	8190	1.5%
5	8085	1.5%
6	7563	1.4%
7	8190	1.5%
8	8190	1.5%
9	8108	1.5%
10	8190	1.5%

Value	Count	Frequency (%)
99	1475	0.3%
98	7468	1.4%
97	7994	1.5%
96	6204	1.2%
95	8190	1.5%
94	7149	1.3%
93	7551	1.4%
92	8190	1.5%
91	8190	1.5%
90	8190	1.5%

Date
Date

Distinct	182
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.1 MiB

Minimum	2010-02-05 00:00:00
Maximum	2013-07-26 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Weekly_Sales
Real number (ℝ)

Missing

Distinct	359464
Distinct (%)	85.3%
Missing	115064
Missing (%)	21.4%
Infinite	0
Infinite (%)	0.0%
Mean	15981.258

Minimum	-4988.94
Maximum	693099.36
Zeros	73
Zeros (%)	< 0.1%
Negative	1285
Negative (%)	0.2%
Memory size	4.1 MiB

Quantile statistics

Minimum	-4988.94
5-th percentile	59.9745
Q1	2079.65
median	7612.03
Q3	20205.853
95-th percentile	61201.951
Maximum	693099.36
Range	698088.3
Interquartile range (IQR)	18126.202

Descriptive statistics

Standard deviation	22711.184
Coefficient of variation (CV)	1.4211136
Kurtosis	21.49129
Mean	15981.258
Median Absolute Deviation (MAD)	6747.645
Skewness	3.2620082
Sum	6.737219 × 10⁹
Variance	5.1579786 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	353	0.1%
5	289	0.1%
20	232	< 0.1%
15	215	< 0.1%
12	175	< 0.1%
1	169	< 0.1%
10.47	167	< 0.1%
11.97	154	< 0.1%
2	148	< 0.1%
7	146	< 0.1%
Other values (359454)	419522	78.2%
(Missing)	115064	21.4%

Value	Count	Frequency (%)
-4988.94	1	< 0.1%
-3924	1	< 0.1%
-1750	1	< 0.1%
-1699	1	< 0.1%
-1321.48	1	< 0.1%
-1098	3	< 0.1%
-1008.96	1	< 0.1%
-898	1	< 0.1%
-863	1	< 0.1%
-798	4	< 0.1%

Value	Count	Frequency (%)
693099.36	1	< 0.1%
649770.18	1	< 0.1%
630999.19	1	< 0.1%
627962.93	1	< 0.1%
474330.1	1	< 0.1%
422306.25	1	< 0.1%
420586.57	1	< 0.1%
406988.63	1	< 0.1%
404245.03	1	< 0.1%
393705.2	1	< 0.1%

IsHoliday_x
Boolean

High correlation Imbalance Missing

Distinct	2
Distinct (%)	< 0.1%
Missing	115064
Missing (%)	21.4%
Memory size	4.1 MiB

False	391909
True	29661
(Missing)	115064

Value	Count	Frequency (%)
False	391909	73.0%
True	29661	5.5%
(Missing)	115064	21.4%

Temperature
Real number (ℝ)

Missing

Distinct	3528
Distinct (%)	0.8%
Missing	115064
Missing (%)	21.4%
Infinite	0
Infinite (%)	0.0%
Mean	60.090059

Minimum	-2.06
Maximum	100.14
Zeros	0
Zeros (%)	0.0%
Negative	69
Negative (%)	< 0.1%
Memory size	4.1 MiB

Quantile statistics

Minimum	-2.06
5-th percentile	27.31
Q1	46.68
median	62.09
Q3	74.28
95-th percentile	87.27
Maximum	100.14
Range	102.2
Interquartile range (IQR)	27.6

Descriptive statistics

Standard deviation	18.447931
Coefficient of variation (CV)	0.30700471
Kurtosis	-0.63592198
Mean	60.090059
Median Absolute Deviation (MAD)	13.63
Skewness	-0.32140415
Sum	25332166
Variance	340.32616
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50.43	709	0.1%
67.87	646	0.1%
72.62	594	0.1%
76.67	583	0.1%
70.28	563	0.1%
76.03	555	0.1%
50.56	544	0.1%
64.05	542	0.1%
64.21	519	0.1%
50.81	487	0.1%
Other values (3518)	415828	77.5%
(Missing)	115064	21.4%

Value	Count	Frequency (%)
-2.06	69	< 0.1%
5.54	68	< 0.1%
6.23	69	< 0.1%
7.46	69	< 0.1%
9.51	70	< 0.1%
9.55	69	< 0.1%
10.09	66	< 0.1%
10.11	68	< 0.1%
10.24	69	< 0.1%
10.53	72	< 0.1%

Value	Count	Frequency (%)
100.14	44	< 0.1%
100.07	46	< 0.1%
99.66	48	< 0.1%
99.22	185	< 0.1%
99.2	46	< 0.1%
98.43	43	< 0.1%
98.15	47	< 0.1%
97.66	42	< 0.1%
97.6	48	< 0.1%
97.18	187	< 0.1%

Fuel_Price
Real number (ℝ)

Missing

Distinct	892
Distinct (%)	0.2%
Missing	115064
Missing (%)	21.4%
Infinite	0
Infinite (%)	0.0%
Mean	3.3610265

Minimum	2.472
Maximum	4.468
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.1 MiB

Quantile statistics

Minimum	2.472
5-th percentile	2.653
Q1	2.933
median	3.452
Q3	3.738
95-th percentile	4.029
Maximum	4.468
Range	1.996
Interquartile range (IQR)	0.805

Descriptive statistics

Standard deviation	0.45851454
Coefficient of variation (CV)	0.13642098
Kurtosis	-1.1854045
Mean	3.3610265
Median Absolute Deviation (MAD)	0.375
Skewness	-0.1049015
Sum	1416908
Variance	0.21023558
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.638	2548	0.5%
3.63	2164	0.4%
2.771	1917	0.4%
3.891	1856	0.3%
3.594	1796	0.3%
3.524	1793	0.3%
3.523	1792	0.3%
2.72	1790	0.3%
3.666	1778	0.3%
2.78	1656	0.3%
Other values (882)	402480	75.0%
(Missing)	115064	21.4%

Value	Count	Frequency (%)
2.472	38	< 0.1%
2.513	45	< 0.1%
2.514	906	0.2%
2.52	39	< 0.1%
2.533	42	< 0.1%
2.539	37	< 0.1%
2.54	147	< 0.1%
2.542	45	< 0.1%
2.545	38	< 0.1%
2.548	902	0.2%

Value	Count	Frequency (%)
4.468	368	0.1%
4.449	358	0.1%
4.308	168	< 0.1%
4.301	360	0.1%
4.294	363	0.1%
4.293	192	< 0.1%
4.288	172	< 0.1%
4.282	173	< 0.1%
4.277	357	0.1%
4.273	366	0.1%

MarkDown1
Real number (ℝ)

High correlation Missing

Distinct	2277
Distinct (%)	1.5%
Missing	385953
Missing (%)	71.9%
Infinite	0
Infinite (%)	0.0%
Mean	7246.4202

Minimum	0.27
Maximum	88646.76
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.1 MiB

Quantile statistics

Minimum	0.27
5-th percentile	149.19
Q1	2240.27
median	5347.45
Q3	9210.9
95-th percentile	21801.35
Maximum	88646.76
Range	88646.49
Interquartile range (IQR)	6970.63

Descriptive statistics

Standard deviation	8291.2213
Coefficient of variation (CV)	1.1441817
Kurtosis	17.606263
Mean	7246.4202
Median Absolute Deviation (MAD)	3430.74
Skewness	3.3418447
Sum	1.0918978 × 10⁹
Variance	68744351
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.5	102	< 0.1%
460.73	102	< 0.1%
175.64	93	< 0.1%
1282.42	75	< 0.1%
9264.48	75	< 0.1%
686.24	75	< 0.1%
5924.71	75	< 0.1%
1483.17	75	< 0.1%
3124.45	74	< 0.1%
6809.96	74	< 0.1%
Other values (2267)	149861	27.9%
(Missing)	385953	71.9%

Value	Count	Frequency (%)
0.27	51	< 0.1%
0.5	49	< 0.1%
1.5	102	< 0.1%
1.94	50	< 0.1%
2.12	52	< 0.1%
2.4	49	< 0.1%
2.42	50	< 0.1%
2.43	51	< 0.1%
2.8	50	< 0.1%
2.91	51	< 0.1%

Value	Count	Frequency (%)
88646.76	68	< 0.1%
78124.5	70	< 0.1%
75149.79	73	< 0.1%
65021.23	73	< 0.1%
62567.6	66	< 0.1%
62172.73	72	< 0.1%
60740.64	70	< 0.1%
60394.73	72	< 0.1%
58928.52	72	< 0.1%
56917.7	71	< 0.1%

MarkDown2
Real number (ℝ)

Missing

Distinct	1499
Distinct (%)	1.3%
Missing	425386
Missing (%)	79.3%
Infinite	0
Infinite (%)	0.0%
Mean	3334.6286

Minimum	-265.76
Maximum	104519.54
Zeros	207
Zeros (%)	< 0.1%
Negative	1311
Negative (%)	0.2%
Memory size	4.1 MiB

Quantile statistics

Minimum	-265.76
5-th percentile	1.95
Q1	41.6
median	192
Q3	1926.94
95-th percentile	16497.47
Maximum	104519.54
Range	104785.3
Interquartile range (IQR)	1885.34

Descriptive statistics

Standard deviation	9475.3573
Coefficient of variation (CV)	2.841503
Kurtosis	37.589561
Mean	3334.6286
Median Absolute Deviation (MAD)	184.73
Skewness	5.4412612
Sum	3.7097076 × 10⁸
Variance	89782396
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.91	539	0.1%
3	493	0.1%
0.5	485	0.1%
1.5	471	0.1%
4	367	0.1%
6	365	0.1%
7.64	354	0.1%
3.82	353	0.1%
19	345	0.1%
5.73	345	0.1%
Other values (1489)	107131	20.0%
(Missing)	425386	79.3%

Value	Count	Frequency (%)
-265.76	71	< 0.1%
-192	72	< 0.1%
-20	72	< 0.1%
-10.98	60	< 0.1%
-10.5	143	< 0.1%
-9.98	68	< 0.1%
-9.94	62	< 0.1%
-7.6	69	< 0.1%
-7.01	69	< 0.1%
-6.69	69	< 0.1%

Value	Count	Frequency (%)
104519.54	72	< 0.1%
97740.99	73	< 0.1%
92523.94	73	< 0.1%
89121.94	74	< 0.1%
82881.16	73	< 0.1%
72413.71	72	< 0.1%
70574.85	71	< 0.1%
58804.91	69	< 0.1%
58046.41	71	< 0.1%
56106.2	72	< 0.1%

MarkDown3
Real number (ℝ)

Missing

Distinct	1662
Distinct (%)	1.2%
Missing	399543
Missing (%)	74.5%
Infinite	0
Infinite (%)	0.0%
Mean	1439.4214

Minimum	-29.1
Maximum	141630.61
Zeros	67
Zeros (%)	< 0.1%
Negative	257
Negative (%)	< 0.1%
Memory size	4.1 MiB

Quantile statistics

Minimum	-29.1
5-th percentile	0.65
Q1	5.08
median	24.6
Q3	103.99
95-th percentile	1059.9
Maximum	141630.61
Range	141659.71
Interquartile range (IQR)	98.91

Descriptive statistics

Standard deviation	9623.0783
Coefficient of variation (CV)	6.6853796
Kurtosis	77.687772
Mean	1439.4214
Median Absolute Deviation (MAD)	22.6
Skewness	8.399453
Sum	1.9733172 × 10⁸
Variance	92603636
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	754	0.1%
6	710	0.1%
2	660	0.1%
1	611	0.1%
0.22	487	0.1%
0.5	463	0.1%
0.01	444	0.1%
4	439	0.1%
3.2	379	0.1%
1.98	363	0.1%
Other values (1652)	131781	24.6%
(Missing)	399543	74.5%

Value	Count	Frequency (%)
-29.1	72	< 0.1%
-1	70	< 0.1%
-0.87	46	< 0.1%
-0.2	69	< 0.1%
0	67	< 0.1%
0.01	444	0.1%
0.02	124	< 0.1%
0.04	241	< 0.1%
0.05	71	< 0.1%
0.06	205	< 0.1%

Value	Count	Frequency (%)
141630.61	74	< 0.1%
109030.75	75	< 0.1%
103991.94	72	< 0.1%
101378.79	73	< 0.1%
89402.64	71	< 0.1%
88805.58	72	< 0.1%
83340.33	74	< 0.1%
83192.81	74	< 0.1%
79621.2	72	< 0.1%
77451.26	73	< 0.1%

MarkDown4
Real number (ℝ)

High correlation Missing

Distinct	1944
Distinct (%)	1.4%
Missing	401667
Missing (%)	74.8%
Infinite	0
Infinite (%)	0.0%
Mean	3383.1683

Minimum	0.22
Maximum	67474.85
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.1 MiB

Quantile statistics

Minimum	0.22
5-th percentile	28.76
Q1	504.22
median	1481.31
Q3	3595.04
95-th percentile	12645.96
Maximum	67474.85
Range	67474.63
Interquartile range (IQR)	3090.82

Descriptive statistics

Standard deviation	6292.384
Coefficient of variation (CV)	1.8599087
Kurtosis	29.996815
Mean	3383.1683
Median Absolute Deviation (MAD)	1167.55
Skewness	4.8475
Sum	4.5661607 × 10⁸
Variance	39594097
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	280	0.1%
4	200	< 0.1%
2	197	< 0.1%
3	146	< 0.1%
47	143	< 0.1%
67.72	142	< 0.1%
657.56	141	< 0.1%
17	141	< 0.1%
8	140	< 0.1%
1330.36	140	< 0.1%
Other values (1934)	133297	24.8%
(Missing)	401667	74.8%

Value	Count	Frequency (%)
0.22	57	< 0.1%
0.41	52	< 0.1%
0.46	48	< 0.1%
0.78	52	< 0.1%
0.87	49	< 0.1%
0.92	45	< 0.1%
1.5	55	< 0.1%
1.88	48	< 0.1%
1.98	44	< 0.1%
2	197	< 0.1%

Value	Count	Frequency (%)
67474.85	72	< 0.1%
57817.56	74	< 0.1%
57815.43	68	< 0.1%
53603.99	72	< 0.1%
52739.02	72	< 0.1%
48403.53	70	< 0.1%
48159.86	73	< 0.1%
48086.64	72	< 0.1%
47452.43	73	< 0.1%
46238.28	71	< 0.1%

MarkDown5
Real number (ℝ)

High correlation Missing

Distinct	2293
Distinct (%)	1.5%
Missing	385202
Missing (%)	71.8%
Infinite	0
Infinite (%)	0.0%
Mean	4628.9751

Minimum	135.16
Maximum	108519.28
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.1 MiB

Quantile statistics

Minimum	135.16
5-th percentile	715.52
Q1	1878.44
median	3359.45
Q3	5563.8
95-th percentile	11269.24
Maximum	108519.28
Range	108384.12
Interquartile range (IQR)	3685.36

Descriptive statistics

Standard deviation	5962.8875
Coefficient of variation (CV)	1.2881658
Kurtosis	107.84927
Mean	4628.9751
Median Absolute Deviation (MAD)	1702.47
Skewness	8.1699095
Sum	7.0097495 × 10⁸
Variance	35556027
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2743.18	136	< 0.1%
1064.56	120	< 0.1%
9083.54	75	< 0.1%
3567.03	75	< 0.1%
3557.67	75	< 0.1%
20371.02	75	< 0.1%
4180.29	75	< 0.1%
1773.53	74	< 0.1%
3932.94	74	< 0.1%
4464.45	74	< 0.1%
Other values (2283)	150579	28.1%
(Missing)	385202	71.8%

Value	Count	Frequency (%)
135.16	65	< 0.1%
153.04	47	< 0.1%
153.9	49	< 0.1%
164.08	52	< 0.1%
170.64	69	< 0.1%
171.76	71	< 0.1%
180.07	64	< 0.1%
212.75	50	< 0.1%
224.86	50	< 0.1%
227.12	48	< 0.1%

Value	Count	Frequency (%)
108519.28	68	< 0.1%
105223.11	70	< 0.1%
85851.87	68	< 0.1%
63005.58	69	< 0.1%
58068.14	69	< 0.1%
57029.78	68	< 0.1%
53212.72	70	< 0.1%
37581.27	70	< 0.1%
36430.33	71	< 0.1%
36360.42	72	< 0.1%

CPI
Real number (ℝ)

Missing

Distinct	2145
Distinct (%)	0.5%
Missing	115064
Missing (%)	21.4%
Infinite	0
Infinite (%)	0.0%
Mean	171.20195

Minimum	126.064
Maximum	227.23281
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.1 MiB

Quantile statistics

Minimum	126.064
5-th percentile	126.49626
Q1	132.02267
median	182.31878
Q3	212.41699
95-th percentile	221.94156
Maximum	227.23281
Range	101.16881
Interquartile range (IQR)	80.394326

Descriptive statistics

Standard deviation	39.159276
Coefficient of variation (CV)	0.22873149
Kurtosis	-1.8297144
Mean	171.20195
Median Absolute Deviation (MAD)	41.434863
Skewness	0.085219285
Sum	72173605
Variance	1533.4489
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
129.8555333	711	0.1%
131.1083333	708	0.1%
129.8459667	707	0.1%
130.6457931	706	0.1%
131.0756667	706	0.1%
130.3849032	706	0.1%
130.683	706	0.1%
130.4546207	705	0.1%
130.7196333	705	0.1%
130.737871	704	0.1%
Other values (2135)	414506	77.2%
(Missing)	115064	21.4%

Value	Count	Frequency (%)
126.064	678	0.1%
126.0766452	679	0.1%
126.0854516	675	0.1%
126.0892903	682	0.1%
126.1019355	686	0.1%
126.1069032	681	0.1%
126.1119032	682	0.1%
126.114	687	0.1%
126.1145806	689	0.1%
126.1266	683	0.1%

Value	Count	Frequency (%)
227.2328068	63	< 0.1%
227.214288	62	< 0.1%
227.1693919	63	< 0.1%
227.0369359	70	< 0.1%
227.0184166	69	< 0.1%
226.9873637	134	< 0.1%
226.9735448	69	< 0.1%
226.9688442	134	< 0.1%
226.9662325	63	< 0.1%
226.9239785	135	< 0.1%

Unemployment
Real number (ℝ)

Missing

Distinct	349
Distinct (%)	0.1%
Missing	115064
Missing (%)	21.4%
Infinite	0
Infinite (%)	0.0%
Mean	7.9602887

Minimum	3.879
Maximum	14.313
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.1 MiB

Quantile statistics

Minimum	3.879
5-th percentile	5.326
Q1	6.891
median	7.866
Q3	8.572
95-th percentile	12.187
Maximum	14.313
Range	10.434
Interquartile range (IQR)	1.681

Descriptive statistics

Standard deviation	1.863296
Coefficient of variation (CV)	0.23407393
Kurtosis	2.7312166
Mean	7.9602887
Median Absolute Deviation (MAD)	0.858
Skewness	1.1837426
Sum	3355818.9
Variance	3.4718721
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8.099	5152	1.0%
8.163	3636	0.7%
7.852	3614	0.7%
7.343	3416	0.6%
7.057	3414	0.6%
7.931	3400	0.6%
7.441	3397	0.6%
6.565	3370	0.6%
8.2	3361	0.6%
6.891	3360	0.6%
Other values (339)	385450	71.8%
(Missing)	115064	21.4%

Value	Count	Frequency (%)
3.879	287	0.1%
4.077	938	0.2%
4.125	1831	0.3%
4.145	562	0.1%
4.156	1815	0.3%
4.261	1829	0.3%
4.308	935	0.2%
4.42	1855	0.3%
4.584	1988	0.4%
4.607	935	0.2%

Value	Count	Frequency (%)
14.313	2636	0.5%
14.18	2423	0.5%
14.099	2441	0.5%
14.021	2263	0.4%
13.975	1529	0.3%
13.736	2464	0.5%
13.503	2661	0.5%
12.89	2491	0.5%
12.187	2507	0.5%
11.627	2502	0.5%

IsHoliday_y
Boolean

High correlation Imbalance Missing

Distinct	2
Distinct (%)	< 0.1%
Missing	115064
Missing (%)	21.4%
Memory size	4.1 MiB

False	391909
True	29661
(Missing)	115064

Value	Count	Frequency (%)
False	391909	73.0%
True	29661	5.5%
(Missing)	115064	21.4%

Type
Categorical

High correlation Missing

Distinct	3
Distinct (%)	< 0.1%
Missing	115064
Missing (%)	21.4%
Memory size	4.1 MiB

A	215478
B	163495
C	42597

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	421570
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	A
2nd row	A
3rd row	A
4th row	A
5th row	A

Common Values

Value	Count	Frequency (%)
A	215478	40.2%
B	163495	30.5%
C	42597	7.9%
(Missing)	115064	21.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
a	215478	51.1%
b	163495	38.8%
c	42597	10.1%

Most occurring characters

Value	Count	Frequency (%)
A	215478	51.1%
B	163495	38.8%
C	42597	10.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	421570	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	215478	51.1%
B	163495	38.8%
C	42597	10.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	421570	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	215478	51.1%
B	163495	38.8%
C	42597	10.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	421570	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	215478	51.1%
B	163495	38.8%
C	42597	10.1%

Size
Real number (ℝ)

High correlation Missing

Distinct	40
Distinct (%)	< 0.1%
Missing	115064
Missing (%)	21.4%
Infinite	0
Infinite (%)	0.0%
Mean	136727.92

Minimum	34875
Maximum	219622
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.1 MiB

Quantile statistics

Minimum	34875
5-th percentile	39690
Q1	93638
median	140167
Q3	202505
95-th percentile	206302
Maximum	219622
Range	184747
Interquartile range (IQR)	108867

Descriptive statistics

Standard deviation	60980.583
Coefficient of variation (CV)	0.44599951
Kurtosis	-1.2063459
Mean	136727.92
Median Absolute Deviation (MAD)	62140
Skewness	-0.32584977
Sum	5.7640387 × 10¹⁰
Variance	3.7186315 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=40)

Value	Count	Frequency (%)
39690	20802	3.9%
39910	20597	3.8%
203819	20376	3.8%
219622	10474	2.0%
126512	10315	1.9%
205863	10272	1.9%
151315	10244	1.9%
202307	10238	1.9%
204184	10225	1.9%
158114	10224	1.9%
Other values (30)	287803	53.6%
(Missing)	115064	21.4%

Value	Count	Frequency (%)
34875	8999	1.7%
37392	9036	1.7%
39690	20802	3.9%
39910	20597	3.8%
41062	6751	1.3%
42988	7156	1.3%
57197	9443	1.8%
70713	9762	1.8%
93188	9864	1.8%
93638	9455	1.8%

Value	Count	Frequency (%)
219622	10474	2.0%
207499	10062	1.9%
206302	10113	1.9%
205863	10272	1.9%
204184	10225	1.9%
203819	20376	3.8%
203750	10142	1.9%
203742	10214	1.9%
203007	10202	1.9%
202505	10211	1.9%

IsHoliday
Boolean

Imbalance Missing

Distinct	2
Distinct (%)	< 0.1%
Missing	421570
Missing (%)	78.6%
Memory size	4.1 MiB

False	106136
True	8928
(Missing)	421570

Value	Count	Frequency (%)
False	106136	19.8%
True	8928	1.7%
(Missing)	421570	78.6%

	CPI	Dept	Fuel_Price	IsHoliday	IsHoliday_x	IsHoliday_y	MarkDown1	MarkDown2	MarkDown3	MarkDown4	MarkDown5	Size	Store	Temperature	Type	Unemployment	Weekly_Sales
CPI	1.000	-0.009	-0.041	0.000	0.012	0.012	-0.017	-0.099	-0.111	-0.063	0.021	-0.005	-0.230	0.173	0.183	-0.383	-0.023
Dept	-0.009	1.000	0.003	0.000	0.000	0.000	0.002	0.003	0.006	0.007	0.006	0.011	0.014	0.001	0.080	0.006	-0.014
Fuel_Price	-0.041	0.003	1.000	0.000	0.136	0.136	0.163	-0.155	-0.218	0.073	-0.088	0.004	0.074	0.128	0.088	-0.060	0.002
IsHoliday	0.000	0.000	0.000	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000
IsHoliday_x	0.012	0.000	0.136	0.000	1.000	1.000	0.057	0.359	0.458	0.115	0.060	0.000	0.000	0.186	0.000	0.035	0.031
IsHoliday_y	0.012	0.000	0.136	0.000	1.000	1.000	0.057	0.359	0.458	0.115	0.060	0.000	0.000	0.186	0.000	0.035	0.031
MarkDown1	-0.017	0.002	0.163	0.000	0.057	0.057	1.000	0.206	0.154	0.759	0.508	0.499	-0.212	0.002	0.172	0.064	0.192
MarkDown2	-0.099	0.003	-0.155	0.000	0.359	0.359	0.206	1.000	0.066	0.116	0.152	0.149	0.009	-0.462	0.066	0.060	0.032
MarkDown3	-0.111	0.006	-0.218	0.000	0.458	0.458	0.154	0.066	1.000	0.002	0.244	0.300	-0.065	-0.257	0.065	0.043	0.135
MarkDown4	-0.063	0.007	0.073	0.000	0.115	0.115	0.759	0.116	0.002	1.000	0.380	0.288	-0.039	0.141	0.066	0.038	0.112
MarkDown5	0.021	0.006	-0.088	0.000	0.060	0.060	0.508	0.152	0.244	0.380	1.000	0.579	-0.156	-0.071	0.094	-0.019	0.208
Size	-0.005	0.011	0.004	0.000	0.000	0.000	0.499	0.149	0.300	0.288	0.579	1.000	-0.160	-0.043	0.851	-0.066	0.290
Store	-0.230	0.014	0.074	0.000	0.000	0.000	-0.212	0.009	-0.065	-0.039	-0.156	-0.160	1.000	-0.057	0.538	0.295	-0.102
Temperature	0.173	0.001	0.128	0.000	0.186	0.186	0.002	-0.462	-0.257	0.141	-0.071	-0.043	-0.057	1.000	0.123	0.030	-0.020
Type	0.183	0.080	0.088	0.000	0.000	0.000	0.172	0.066	0.065	0.066	0.094	0.851	0.538	0.123	1.000	0.181	0.089
Unemployment	-0.383	0.006	-0.060	0.000	0.035	0.035	0.064	0.060	0.043	0.038	-0.019	-0.066	0.295	0.030	0.181	1.000	-0.016
Weekly_Sales	-0.023	-0.014	0.002	0.000	0.031	0.031	0.192	0.032	0.135	0.112	0.208	0.290	-0.102	-0.020	0.089	-0.016	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	Store	Dept	Date	Weekly_Sales	IsHoliday_x	Temperature	Fuel_Price	MarkDown1	MarkDown2	MarkDown3	MarkDown4	MarkDown5	CPI	Unemployment	IsHoliday_y	Type	Size	IsHoliday
0	1	1	2010-02-05	24924.50	False	42.31	2.572	NaN	NaN	NaN	NaN	NaN	211.096358	8.106	False	A	151315.0	NaN
1	1	2	2010-02-05	50605.27	False	42.31	2.572	NaN	NaN	NaN	NaN	NaN	211.096358	8.106	False	A	151315.0	NaN
2	1	3	2010-02-05	13740.12	False	42.31	2.572	NaN	NaN	NaN	NaN	NaN	211.096358	8.106	False	A	151315.0	NaN
3	1	4	2010-02-05	39954.04	False	42.31	2.572	NaN	NaN	NaN	NaN	NaN	211.096358	8.106	False	A	151315.0	NaN
4	1	5	2010-02-05	32229.38	False	42.31	2.572	NaN	NaN	NaN	NaN	NaN	211.096358	8.106	False	A	151315.0	NaN
5	1	6	2010-02-05	5749.03	False	42.31	2.572	NaN	NaN	NaN	NaN	NaN	211.096358	8.106	False	A	151315.0	NaN
6	1	7	2010-02-05	21084.08	False	42.31	2.572	NaN	NaN	NaN	NaN	NaN	211.096358	8.106	False	A	151315.0	NaN
7	1	8	2010-02-05	40129.01	False	42.31	2.572	NaN	NaN	NaN	NaN	NaN	211.096358	8.106	False	A	151315.0	NaN
8	1	9	2010-02-05	16930.99	False	42.31	2.572	NaN	NaN	NaN	NaN	NaN	211.096358	8.106	False	A	151315.0	NaN
9	1	10	2010-02-05	30721.50	False	42.31	2.572	NaN	NaN	NaN	NaN	NaN	211.096358	8.106	False	A	151315.0	NaN

	Store	Dept	Date	Weekly_Sales	IsHoliday_x	Temperature	Fuel_Price	MarkDown1	MarkDown2	MarkDown3	MarkDown4	MarkDown5	CPI	Unemployment	IsHoliday_y	Type	Size	IsHoliday
536624	45	85	2013-07-26	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	False
536625	45	87	2013-07-26	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	False
536626	45	90	2013-07-26	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	False
536627	45	91	2013-07-26	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	False
536628	45	92	2013-07-26	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	False
536629	45	93	2013-07-26	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	False
536630	45	94	2013-07-26	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	False
536631	45	95	2013-07-26	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	False
536632	45	97	2013-07-26	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	False
536633	45	98	2013-07-26	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	False

Overview

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample